﻿namespace EasyWeb.Data
{
    using System;
    using System.Collections.Generic;
    using System.Data;

    public interface IEWDdlSqlGenerator
    {
        string Version { get; set; }
        string CreateTable(string tableName, IEnumerable<Tuple<string, DbType, bool>> columns);
        string CreateColumn(string tableName, string columnName, DbType columnType, bool allowNull);
        string ChangeTableName(string oldTableName, string newTableName);
        string ChangeColumnName(string tableName, string oldColumnName, string newColumnName);
        string ChangeColumnType(string tableName, string columnName, DbType columnType, bool allowNull);
        string DeleteTable(string tableName);
        string DeleteColumn(string tableName, string columnName);
        string CreatePrimaryKey(string tableName, string columnName);
    }
}
